package com.wuhuahe.learning.multitable.mapper;

import com.wuhuahe.learning.multitable.pojo.Role;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface IRoleMapper {

    @Select("select * from public.role r, public.user_role ur where ur.roleid=r.id and ur.userid=#{uid}")
    List<Role> findRoleByUid(Integer uid);
}
